Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
ReversalTransactionID (FK) | A universally unique identifier (UUID) for the a new Transaction that reverses the Transaction being cancelled. | ID_TRN_RVS | IdentityUUID | char(32) | Transaction(TR_TRN) |
CancelledTransactionID (FK) | A universally unique identifier (UUID) for the Transaction that is being cancelled. | ID_TRN_CNL | IdentityUUID | char(32) | Transaction(TR_TRN) |
VoidTypeCode | A mnemonic code denoting the kind of Transaction Void operation that is being performed. e.g. PostVoid, Void, SuspendDelete | CD_TYP_VD | Code4 | char(4) | |
VoidAmount | The monetary value of the Transaction being cancelled after it was completed. | MO_VD | MoneyShortRetail | decimal(7,2) | |
VoidQuantity | The number of Items in the Transaction being cancelled after it was completed. | QU_VD | Quantity | DECIMAL(9,3) | |